<!--Set Defaults if the userdirectory does not have corresponding data in the INI file-->
<CFSET Enumerate="select Name, 'User' as Class from SmUser Union select Name, 'Group' as Class from SmGroup order by Class">
<CFSET Lookup="select Name, 'User' as Class from SmUser where Name %s Union select Name, 'Group' as Class from SmGroup where Name %s order by Class">
<CFSET InitUser="select Name from SmUser where Name = '%s'">
<CFSET AuthenticateUser="select Name from SmUser where Name = '%s' and Password = '%s'">
<CFSET IsGroupMember="select ID from SmUserGroup where UserID = (select UserID from SmUser where Name = '%s') and GroupID = (select GroupID from SmGroup where Name = '%s')">
<CFSET GetUserGroups="select SmGroup.Name from SmGroup, SmUser, SmUserGroup where SmUser.Name = '%s' and SmUser.UserID = SmUserGroup.UserID and SmGroup.GroupID = SmUserGroup.GroupID">
<cfif Find("select UserName as Name",#Enumerate#)>
<!--Spectra UserDirectory Defaults-->
<CFSET LookupUsers="select UserName, 'User' as Class from Users where %s">
<CFSET LookupGroups="select UserName, 'Group' as Class from Groups where %s">
<CFSET GetUserOrGroupInfo="select UserName as Name, 'User' from Users where UserName = '%s' Union select GroupName as Name, 'Group' from Groups where GroupName = '%s'">
<CFSET GetGroupProperties="select GroupName, Desciption from Group">
<CFSET GetGroupProperty="select %s from Groups where UserName = '%s'">
<CFSET SetGroupProperty="update Groups set %s = %s where UserName = '%s'">
<cfelse>
<CFSET LookupUsers="select Name, 'User' as Class from SmUser where %s">
<CFSET LookupGroups="select Name, 'Group' as Class from SmGroup where %s">
<CFSET GetUserOrGroupInfo="select Name, 'User' from SmUser where Name = '%s' Union select Name, 'Group' from SmGroup where Name = '%s'">
<CFSET GetGroupProperties="select Name, GroupID from SmGroup">
<CFSET GetGroupProperty="select %s from SmGroup where Name = '%s'">
<CFSET SetGroupProperty="update SmGroup set %s = %s where Name = '%s'">
<CFFILE ACTION="Append" FILE="#LOGFILE#" OUTPUT="Unable to Extract the inifile #INIFILE# and using defaults">
<cfif UserDirectories.Name IS "UserDirectory">
<!--Spectra UserDirectory Defaults-->
<CFSET Enumerate="select UserName as Name, 'User' as Class from Users Union select GroupName as Name, 'Group' as Class from Groups order by Class">
<CFSET InitUser="select UserName as Name from Users where UserName = '%s'">
<CFSET AuthenticateUser="select UserName as Name from Users where UserName = '%s' and Password = '%s'">
<CFSET Lookup="select UserName as Name, 'User' from Users where UserName = '%s' Union select GroupName as Name, 'Group' from Groups where GroupName = '%s'">
<CFSET IsGroupMember="select GroupName from Users_Groups where UserName = '%s' and GroupName = '%s'">
<CFSET GetUserGroups="select Groups.GroupName as Name from Groups, Users_Groups where Users_Groups.UserName = '%s' and Groups.GroupName = Users_Groups.GroupName">
<CFSET GetUserProperties="UserName, Description">
<CFSET GetUserProperty="select %s from Users where UserName = '%s'">
<CFSET SetUserProperty="update Users set %s = %s where UserName = '%s'">
<CFSET LookupUsers="select UserName, 'User' as Class from Users where %s">
<CFSET LookupGroups="select UserName, 'Group' as Class from Groups where %s">
<CFSET GetUserOrGroupInfo="select UserName as Name, 'User' from Users where UserName = '%s' Union select GroupName as Name, 'Group' from Groups where GroupName = '%s'">
<CFSET GetGroupProperties="select GroupName, Desciption from Group">
<CFSET GetGroupProperty="select %s from Groups where UserName = '%s'">
<CFSET SetGroupProperty="update Groups set %s = %s where UserName = '%s'">
<cfelse>
<CFSET Enumerate="select Name, 'User' as Class from SmUser Union select Name, 'Group' as Class from SmGroup order by Class">
<CFSET Lookup="select Name, 'User' as Class from SmUser where Name %s Union select Name, 'Group' as Class from SmGroup where Name %s order by Class">
<CFSET InitUser="select Name from SmUser where Name = '%s'">
<CFSET AuthenticateUser="select Name from SmUser where Name = '%s' and Password = '%s'">
<CFSET IsGroupMember="select ID from SmUserGroup where UserID = (select UserID from SmUser where Name = '%s') and GroupID = (select GroupID from SmGroup where Name = '%s')">
<CFSET GetUserGroups="select SmGroup.Name from SmGroup, SmUser, SmUserGroup where SmUser.Name = '%s' and SmUser.UserID = SmUserGroup.UserID and SmGroup.GroupID = SmUserGroup.GroupID">